CREATE EXTERNAL TABLE `spmi_ods`.`spmn_transfer_area_relation`(`id` bigint COMMENT '主键ID', `fee_id` bigint COMMENT '中转费ID', `area_id` bigint COMMENT '目的地ID', `area_type` smallint COMMENT '目的地类型1:目的地2:目的网点')
COMMENT '中转费明细-目的地关系表'
PARTITIONED BY (`dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION 'hdfs://yl-bg-hdp/dw/hive/spmi_ods.db/external/spmn_transfer_area_relation';